package mx.bd;

public class BD {
	
    ///////////////////////////////////////////////////////////////////////////
    /*
     * 	BD TABLAS Y CONFIGURACION
     */
    ///////////////////////////////////////////////////////////////////////////
	
	public static final int	   BD_VERSION = 1;
	public static final String BD_FILE_CONSOLE = "00_CONSOLE.sql";
	public static final String BD_FILE_VGAME = "01_VGAME.sql";
	public static final String BD_FILE_VGAME_VCONSOLE = "02_VGAME_VCONSOLE.sql";
	public static final String BD_FILE_VPORTRAIT = "03_VPORTRAIT.sql";
	public static final String BD_FILE_VGAME_VPORTRAIT = "04_VGAME_VPORTRAIT.sql";
	public static final String BD_FILE_VIMAGE = "05_VIMAGE.sql";
	public static final String BD_FILE_VGAME_VIMAGE = "06_VGAME_VIMAGE.sql";
	public static final String BD_FILE_VVIDEO = "07_VVIDEO.sql";
	public static final String BD_FILE_VGAME_VVIDEO = "08_VGAME_VVIDEO.sql";
	public static final String BD_FILE_PRAGMA_KEYS = "09_PRAGMA_KEYS.sql";
	
	public static final String BD_NAME = "vgame.db";
	public static final String CONSOLE = "CONSOLE";
	public static final String VGAME = "VGAME";
	public static final String VGAME_VCONSOLE = "VGAME_VCONSOLE";
	public static final String VPORTRAIT = "VPORTRAIT";
	public static final String VGAME_VPORTRAIT = "VGAME_VPORTRAIT";
	public static final String VIMAGE = "VIMAGE";
	public static final String VGAME_VIMAGE = "VGAME_VIMAGE";
	public static final String VVIDEO = "VVIDEO";
	public static final String VGAME_VVIDEO = "VGAME_VVIDEO";
	
    ///////////////////////////////////////////////////////////////////////////
    /*
     * 	COLUMNAS LLAVE EN SELECT
     */
    ///////////////////////////////////////////////////////////////////////////

	public static String nIDvgame = "nIDvgame";
	public static String nIDconsole = "nIDconsole";
	public static String nIDvportrait = "nIDvportrait";
	public static String nIDvimage = "nIDvimage";
	public static String nIDvvideo = "nIDvvideo";
	public static String sUri = "sUri";
	
    ///////////////////////////////////////////////////////////////////////////
    /*
     * 	SELECT QUERYS
     */
    ///////////////////////////////////////////////////////////////////////////

	public static String selectConsoles = "SELECT nIDconsole, sConsole FROM CONSOLE;";
	
	/**
	 * No instances from this class
	 */
	private BD() {	}

}// BD
